CREATE VIEW acms.User_View
AS
SELECT        Id, SiteId, UserName, FirstName, LastName, DateOfBirth, EmailAddress, Gender, Address1, Address2, Town, County, PostCode, MobileTel, CustomBool1, 
                         CustomBool2, CustomBool3, CustomInt1, CustomInt2, CustomInt3, CustomString1, CustomString2, CustomString3, EmailAuthenticated, Created, Password, 
                         Salt, Locked, VersionId, LastLogin, LastActivity, LastChangedPassword, LastLocked
FROM            acms.Users
WHERE        (Deleted = 0)